Column and table collation
When replicating from one Microsoft SQL Server database to another, column and table collations will be replicated to the target.
Information note
To support collation replication, the DBA must ensure that the collations defined for the source Microsoft SQL Server database are the same as those defined for the target Microsoft SQL Server database.
Non-nullable columns and primary/unique index names
Primary/Unique Index names are preserved during homogeneous replication. Non-nullable columns are also preserved during homogeneous replication, with the exception of the following data types:
- text
- ntext1
- varchar(max)
- nvarchar(max)
- varbinary(max)
- image
- xml